

In [14]:

    
import pandas as pd
import numpy as np

# Visu 
import matplotlib.pyplot as plt
import seaborn as sns

# Pour voir les graphiques sur le notebook
%matplotlib inline 

# Pour pouvoir visualiser toutes les colonnes du DF
pd.set_option('display.max_columns', 30) # Changer le nombre de colonnnes afficher dans le notebook
pd.set_option('display.max_rows',90)     # Changer le nombre de ligne afficher dans le notebook


# Pour afficher des images (pas besoin de taper cet import)
from IPython.display import Image



In [8]:

    
# Charger le fichier
data = pd.read_csv("data/immobilier.csv")



In [15]:

    
Image(url="http://i.giphy.com/3o7abrH8o4HMgEAV9e.gif")









    Out[15]:

Projet :

Faire une analyse Maccro et Miccro du fichier

Trouver des anomalies

Montrer des relations avec la variables SalePrice

Description des variables :

SalePrice : the property's sale price in dollars.
MSSubClass: The building class
MSZoning: The general zoning classification
LotFrontage: Linear feet of street connected to property
LotArea: Lot size in square feet
Street: Type of road access
Alley: Type of alley access
LotShape: General shape of property
LandContour: Flatness of the property
Utilities: Type of utilities available
LotConfig: Lot configuration
LandSlope: Slope of property
Neighborhood: Physical locations within Ames city limits
Condition1: Proximity to main road or railroad
Condition2: Proximity to main road or railroad (if a second is present)
BldgType: Type of dwelling
HouseStyle: Style of dwelling
OverallQual: Overall material and finish quality
OverallCond: Overall condition rating
YearBuilt: Original construction date
YearRemodAdd: Remodel date
RoofStyle: Type of roof
RoofMatl: Roof material
Exterior1st: Exterior covering on house
Exterior2nd: Exterior covering on house (if more than one material)
MasVnrType: Masonry veneer type
MasVnrArea: Masonry veneer area in square feet
ExterQual: Exterior material quality
ExterCond: Present condition of the material on the exterior
Foundation: Type of foundation
BsmtQual: Height of the basement
BsmtCond: General condition of the basement
BsmtExposure: Walkout or garden level basement walls
BsmtFinType1: Quality of basement finished area
BsmtFinSF1: Type 1 finished square feet
BsmtFinType2: Quality of second finished area (if present)
BsmtFinSF2: Type 2 finished square feet
BsmtUnfSF: Unfinished square feet of basement area
TotalBsmtSF: Total square feet of basement area
Heating: Type of heating
HeatingQC: Heating quality and condition
CentralAir: Central air conditioning
Electrical: Electrical system
1stFlrSF: First Floor square feet
2ndFlrSF: Second floor square feet
LowQualFinSF: Low quality finished square feet (all floors)
GrLivArea: Above grade (ground) living area square feet
BsmtFullBath: Basement full bathrooms
BsmtHalfBath: Basement half bathrooms
FullBath: Full bathrooms above grade
HalfBath: Half baths above grade
Bedroom: Number of bedrooms above basement level
Kitchen: Number of kitchens
KitchenQual: Kitchen quality
TotRmsAbvGrd: Total rooms above grade (does not include bathrooms)
Functional: Home functionality rating
Fireplaces: Number of fireplaces
FireplaceQu: Fireplace quality
GarageType: Garage location
GarageYrBlt: Year garage was built
GarageFinish: Interior finish of the garage
GarageCars: Size of garage in car capacity
GarageArea: Size of garage in square feet
GarageQual: Garage quality
GarageCond: Garage condition
PavedDrive: Paved driveway
WoodDeckSF: Wood deck area in square feet
OpenPorchSF: Open porch area in square feet
EnclosedPorch: Enclosed porch area in square feet
3SsnPorch: Three season porch area in square feet
ScreenPorch: Screen porch area in square feet
PoolArea: Pool area in square feet
PoolQC: Pool quality
Fence: Fence quality
MiscFeature: Miscellaneous feature not covered in other categories
MiscVal: $Value of miscellaneous feature
MoSold: Month Sold
YrSold: Year Sold
SaleType: Type of sale
SaleCondition: Condition of sale

Soutenance et notation :

Par groupe de 2, 3 et 4 personnes

Communication de vos résultats (attente pro)
Répartition du temps de parole
PPT (non obligatoire) / Notebook + description des résultats (Markdown) (obligatoire)
+/- 10 min de présentation + 5 Q/R
Présenter une problématique pro (achat dans l'immobilier), rentabiliser et comprendre le prix du bien
Vous pouvez rentrer dans un rôle (équipe d'agents immobilier, investissement, conseils etc...)
Structurer et argumenter le message que vous voulez faire passer
Outre la technique le raisonnement sera noté :
- Pourquoi vous êtes venus à cette solution technique
- Quelles questions / hypothèses vous vous êtes posés
- Etc...
Je pendrais 2 rôles durant la soutenance :
- Votre responsable, vous devez donc m'expliquer le problème et les solutions mises en place de façon simple.
- Expert technique : là vous pouvez me parler plus de technique



In [17]:

    
Image(url="http://i.giphy.com/o0vwzuFwCGAFO.gif")









    Out[17]:

Aide

Vous pouvez utiliser internet stackoverflow et divers documentations. Il est fortement conseillé d'utiliser les cours précédents ;)

---------------------------------------------------------------- ENJOY ---------------------------------------------------------------------



In [20]:

    
Image(url="http://i.giphy.com/iZMBOB8mlSHgk.gif")









    Out[20]: